<!DOCTYPE html>
<html>
<head>
<meta charset="windows-1255">
<title>Nofshon Servlets Test Page</title>
</head>
<body>


<form action="VacationHandleServlet" method="POST">
<h1>Add New Booking (Insert query)</h1><br>

<input type="hidden" name="method" value="insert">
<input type="hidden" name="orderID" value="1">
<input type="hidden" name="bookingID" value="1">

<b>Name: </b>
<input type="text" name="txtName" /><br>

<b>Passport: </b>
<input type="text" name="txtPassport" /><br>

<b>Depart Flight ID: </b>
<input type="number" name="nDepartFlightID" /><br>

<b>Return Flight ID: </b>
<input type="number" name="nReturnFlightID" /><br>

<b>Hotel ID: </b>
<input type="number" name="nHotelID" /><br>

<b>Number Of Nights: </b>
<input type="number" name="nNumOfNights" /><br>

<p><b>Submit to server</b><br><input type="submit" value="Submit"></p>
</form>

<a href ="VacationHandleServlet?id=2"><h1>Delete Booking #2 (Delete query)</h1></a><br>

<form action="VacationHandleServlet" method="POST">
<h1>Update data in booking #3 (Update query)</h1><br>

<input type="hidden" name="method" value="update">
<input type="hidden" name="orderID" value="1">
<input type="hidden" name="bookingID" value="3">

<b>Name: </b>
<input type="text" name="txtName" /><br>

<b>Passport: </b>
<input type="text" name="txtPassport" /><br>

<b>Depart Flight ID: </b>
<input type="number" name="nDepartFlightID" /><br>

<b>Return Flight ID: </b>
<input type="number" name="nReturnFlightID" /><br>

<b>Hotel ID: </b>
<input type="number" name="nHotelID" /><br>

<b>Number Of Nights: </b>
<input type="number" name="nNumOfNights" /><br>

<p><b>Submit to server</b><br><input type="submit" value="Update"></p>
</form>


<a href="Search?searchtype=ReturnFlights&flightID=3&nightsNumber=5"><h1>Search for hotels in Tel-Aviv (Select query)</h1></a><br>

<form action="UserServlet" method="POST">
<h1>Login to system (Select query with join)</h1><br>


<b>Userame: </b>
<input type="text" name="username" /><br>

<b>Password: </b>
<input type="password" name="password" /><br>

<input type="submit" value="Login"></p>
</form>

<a href="UserServlet"><h1>Get online users (Redis)</h1></a>

<a href="DBServlet"><h1>Rebuild Database</h1></a>

</body>
</html>